package wms.dao.goods;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import wms.dao.BaseMapper;
import wms.entity.Goods;

/**
 * 物资
 * TODO
 * @description: 
 * @author 浮~沉
 * @date 2020年6月25日
 */
public interface GoodsMapper extends BaseMapper<Goods>{
	
	/**
	 * 动态查询
	 * @param goodsName
	 * @param goodsCode
	 * @param type
	 * @return
	 * @throws Exception
	 */
	List<Goods> listAllGoodsWithParam(@Param("goodsName") String goodsName, @Param("goodsCode") String goodsCode, @Param("type") Integer type,
			@Param("startPage")Integer startPage, @Param("pageSize") Integer pageSize) throws Exception;
	
	Goods getGoods(@Param("goodsCode") String goodsCode) throws Exception;
	
	int getTotalCount(@Param("goodsName") String goodsName, @Param("goodsCode") String goodsCode, @Param("type") Integer type) throws Exception;
	
	
	List<Goods> listGoodsWithSupplyCode(@Param("supplyCode")String supplyCode) throws Exception;
	
	List<Goods> listGoodsWithRepoCode(@Param("repoCode")String repoCode) throws Exception;
}
